﻿if exists (select * from dbo.sysobjects where name = 'sp_tb_Payment_Update')
	drop procedure [dbo].[sp_tb_Payment_Update]
Go 
CREATE PROCEDURE dbo.sp_tb_Payment_Update
@Id	int,
@UserId	varchar(50),
@ServiceId	int,
@DateTime	smalldatetime(),
@Amount	money,
@Phone	varchar(12),
@Status	bit
AS
UPDATE tb_Payment SET [UserId] = @UserId,[ServiceId] = @ServiceId,[DateTime] = @DateTime,[Amount] = @Amount,[Phone] = @Phone,[Status] = @Status
WHERE  Id= @Id
Go